Jazz CMS Wiki
Home Page
All Pages
Categories
About Us
WiebeWorks
CMS
CMS Administration
GUI
Jazz
Jazz Administration
Jazz Web Parts
Library
misc
Roles
Solutions
Training
Web Parts
Web Service
Website Design
Website Procedures
Wiki conventions
WordML
Workflow Administration
Quick Search
»
Advanced Search »
Back
Building Filters
Modified on 2017/05/25 14:49
by
Charles
Categorized as
GUI
,
Jazz
{toc} ===Building Filters=== This page should be used as a reference for building filters and reports. Use the property names in the object for filters and reports. This document explains how to get the most out of creating filters to reduce the number of records being viewed and creating reports to provide better data output. ====Boolean==== Properties with true/false values require the property name and property value. * Boolean example: 'IsCompleted=true' ====DateTime==== * Use a 'dot expression' to match dates and times. * DateTime property example: 'StartDate.Year=2014' * DateTime Between Filter example: 'StartDate.Year Between 2014,2015' * Other DateTime dot properties: Date, Day, DayOfWeek, Hour Month, TimeOfDay, Year ====Date==== Date is identical to DateTime, except that it ONLY includes the Date component. ====DateTimeOffset==== DateTimeOffset is identical to DateTime, except that it includes a LocalDateTime, Offset, UtcDateTime ====TimeSpan==== * Use a 'dot expression' to match Time Spans. * TimeSpan property example: 'Duration.Hours=11' * TimeSpan Between Filter example: 'Duration.Hours Between 11,13' * Other TimeSpan dot properties: Days, Hours, Minutes, Seconds, TotalDays, TotalHours, TotalMinutes, TotalSeconds ====Id==== * The key to the record is the 'Id'.This points to only one record. * Id example: 'Id=ed662309-55e0-40cd-bdf7-b1852124d748' will get one record. ====Guid==== * Many classes have properties that point to other classes -these are called foreign keys. The property type is a Guid.The property name will vary, but tends to be the class name + 'Id', e.g.TagId points to a record in the Tag table. * Guid property example: 'TagId=ed662309-55e0-40cd-bdf7-b1852124d748' ====String==== * Text - based Properties, such as 'Name', require the property name and property value with NO QUOTES. * String example: 'Name = John Smith'. (Spaces are optional.) ====Color==== Color Filters can be defined as 'Color=Black'. ====Int32==== Integer filters can be defined as 'Count>0'. ====Decimal==== Decimal filters can be defined as 'Count>0'. ====Double==== Double filters can be defined as 'Count>0'. ====Int64==== Long filters can be defined as 'Count>0'. ====Complex Filter Expressions==== * Multiple filters are supported for AND and OR. * Multiple filter example: 'StartDate.Year=2014 & IsCompleted=true & Name = John Smith' - look for objects where ALL of these conditions are satisfied. * Multiple filter example: 'StartDate.Year=2014 | IsCompleted=true | Name = John Smith' - look for objects where any of these conditions are satisfied. ===Enumerations Overview=== An enumeration is a complete, ordered listing of all the items in a collection. The term is commonly used in mathematics and computer science to refer to a listing of all of the elements of a set. ====AccessTarget==== None example: AccessTarget=None ====ActionType==== DesktopAlert example: ActionType=DesktopAlert ====AssetType==== None example: AssetType=None ====CatanPlayerType==== Player example: CatanPlayerType=Player ====CatanPlayerStatus==== NotLoggedIn example: CatanPlayerStatus=NotLoggedIn ====CatanPlayingState==== StartTurn example: CatanPlayingState=StartTurn ====CatanGameState==== OrderOfPlayers example: CatanGameState=OrderOfPlayers ====CategoryType==== Category example: CategoryType=Category ====ClassType==== ToDo example: ClassType=ToDo ====ConditionType==== IfThenElse example: ConditionType=IfThenElse ====Country==== Eritrea example: Country=Eritrea ====EmployeeType==== Coach example: EmployeeType=Coach ====LogCategory==== WP7_Skydrive example: LogCategory=WP7_Skydrive ====LogType==== Cloud example: LogType=Cloud ====MessageType==== Outgoing example: MessageType=Outgoing ====NotificationType==== None example: NotificationType=None ====Province==== Kansas example: Province=Kansas ====VolunteerType==== Family example: VolunteerType=Family ====ActiveStatus==== * Active: ActiveStatusId=0 * Inactive: ActiveStatusId=1 ====AccessType==== * Deny: AccessTypeId=0 * Allow: AccessTypeId=1 * Read Only: AccessTypeId=2 * Deny Members: AccessTypeId=3 * Allow Members: AccessTypeId=4 * Read-Only Members: AccessTypeId=5 ====AssignmentStatus==== * Tentative: AssignmentStatusId=0 * Assigned: AssignmentStatusId=1 * Substitute: AssignmentStatusId=2 * Unassigned: AssignmentStatusId=3 ====AudioType==== * None: AudioTypeId=0 * Voice: AudioTypeId=1 * Music: AudioTypeId=2 * BackgroundType * Solid Color: BackgroundTypeId=0 * Gradient Color: BackgroundTypeId=1 * Photo: BackgroundTypeId=2 ====Clearance==== * '': ClearanceId=0 * Cleared: ClearanceId=1 * Reconciliated: ClearanceId=2 ====ContactStatus==== * Valid: ContactStatusId=0 * Suspended: ContactStatusId=1 * Expired: ContactStatusId=2 ====CostInfo==== * None: CostInfoId=0 * Cost By Department: CostInfoId=1 * Cost By Project: CostInfoId=2 * Cost By Contact: CostInfoId=3 * Fixed Cost: CostInfoId=4 ====ErrorLevel==== * Store no logs: ErrorLevelId=0 * Store Errors only: ErrorLevelId=1 * Store Errors, Info, Audits: ErrorLevelId=2 * Store all logs: ErrorLevelId=3 ====FontFamily==== * Segoe W P: FontFamilyId=0 * Calabri: FontFamilyId=1 * Comic Sans M S: FontFamilyId=2 * Courier New: FontFamilyId=3 * Lucida Sans Unicode: FontFamilyId=4 * Tahoma: FontFamilyId=5 * Times New Roman: FontFamilyId=6 * Yu Gothic: FontFamilyId=7 * Arial Black: FontFamilyId=8 * Wingdings: FontFamilyId=9 * Webdings: FontFamilyId=10 * Trebuchet M S: FontFamilyId=11 * Georgia: FontFamilyId=12 ====FontSize==== * 24: FontSizeId=0 * 28: FontSizeId=1 * 32: FontSizeId=2 * 36: FontSizeId=3 * 40: FontSizeId=4 * 48: FontSizeId=5 * 54: FontSizeId=6 ====ImportanceUrgence==== * Important and Urgent: ImportanceUrgenceId=0 * Important and Not Urgent: ImportanceUrgenceId=1 * Not Important and Urgent: ImportanceUrgenceId=2 * Not Important and Not Urgent: ImportanceUrgenceId=3 ====Priority==== * Low: PriorityId=0 * Medium: PriorityId=1 * High: PriorityId=2 * Must: PriorityId=3 ====ProjectStatus==== * Not Started: ProjectStatusId=0 * Active: ProjectStatusId=1 * Completed: ProjectStatusId=2 ====Recurrence==== * No: RecurrenceId=0 * Daily: RecurrenceId=1 * Weekly: RecurrenceId=2 * Monthly: RecurrenceId=3 * Yearly: RecurrenceId=4 ====ResourceType==== * Contact: ResourceTypeId=0 * Location: ResourceTypeId=1 ====SlideShowOrder==== * Image Created Date: SlideShowOrderId=0 * File Created Date: SlideShowOrderId=1 * Order: SlideShowOrderId=2 ====SlideShowSelection==== * By Tag: SlideShowSelectionId=0 * By Folder: SlideShowSelectionId=1 * All: SlideShowSelectionId=2 ====SortOrderDisplay==== * none: SortOrderDisplayId=0 * Ascending: SortOrderDisplayId=1 * Descending: SortOrderDisplayId=2 ====SortPropertyDisplay==== * none: SortPropertyDisplayId=0 * Name: SortPropertyDisplayId=1 * Created on: SortPropertyDisplayId=2 * Created by: SortPropertyDisplayId=3 * Site name: SortPropertyDisplayId=4 * Updated on: SortPropertyDisplayId=5 * Updated by: SortPropertyDisplayId=6 ====StartPage==== * Main: StartPageId=0 * Tasks: StartPageId=1 * Projects: StartPageId=2 * To Dos: StartPageId=3 * Tags: StartPageId=4 * Notes: StartPageId=5 * Sign In: StartPageId=6 * Notes Editor: StartPageId=7 * Timesheets: StartPageId=8 * New Timesheet: StartPageId=9 * Expenses: StartPageId=10 * New Expense: StartPageId=11 * S T O R E: StartPageId=12 * D E M O: StartPageId=13 * Banners: StartPageId=14 * New Banner: StartPageId=15 * Map Route: StartPageId=16 * All Routes: StartPageId=17 * All Locations: StartPageId=18 * Edit Location: StartPageId=19 ====StartState==== * Not Started: StartStateId=0 * Active: StartStateId=1 ====StorageType==== * Session: StorageTypeId=0 * Local Database: StorageTypeId=1 * Cloud [ Logs only]: StorageTypeId=2 * Cloud: StorageTypeId=3 ====TaskDueDate==== * No date: TaskDueDateId=0 * Today at 12pm: TaskDueDateId=1 * Tomorrow at 12pm: TaskDueDateId=2 * Next Week at 12pm: TaskDueDateId=3 ====TaskState==== * Unscheduled: TaskStateId=0 * Delayed: TaskStateId=1 * Today: TaskStateId=2 * Tomorrow: TaskStateId=3 * Next: TaskStateId=4 * Completed: TaskStateId=5 ====Theme==== * Dark: ThemeId=0 * Light: ThemeId=1 ====TermsType==== * Now Due: TermsTypeId=0 * Due in 2 weeks: TermsTypeId=1 * Due in 30 days: TermsTypeId=2 * Due in 60 days: TermsTypeId=3 * Due by end of month: TermsTypeId=4 ====TimesheetStatus==== * Not Started: TimesheetStatusId=0 * Submitted: TimesheetStatusId=1 * Approved: TimesheetStatusId=2 * Locked: TimesheetStatusId=3 ====TimeslipStatus==== * Not Started: TimeslipStatusId=0 * Submitted: TimeslipStatusId=1 * Locked: TimeslipStatusId=2 ====TravelMode==== * Driving: TravelModeId=0 * Walking: TravelModeId=1 * Running: TravelModeId=2 * Road Biking: TravelModeId=3 * Mountain Biking: TravelModeId=4 * Swimming: TravelModeId=5 * Canoeing: TravelModeId=6 ====TypeOfTimeslip==== * Straight Time: TypeOfTimeslipId=0 * Regular Overtime: TypeOfTimeslipId=1 * Premium Overtime: TypeOfTimeslipId=2 * Time-off in lieu Credit: TypeOfTimeslipId=3 * Time-off in lieu Debit: TypeOfTimeslipId=4 ====SupportedLanguages==== * English: SupportedLanguagesId=en * Finnish: SupportedLanguagesId=fi * French: SupportedLanguagesId=fr * German: SupportedLanguagesId=de * Italian: SupportedLanguagesId=it * Portuguese: SupportedLanguagesId=pt * Russian: SupportedLanguagesId=ru * Spanish: SupportedLanguagesId=es * Swedish: SupportedLanguagesId=sw
Meta Keywords:
Meta Description:
Change Comment:
http://www.wiebeworks.com
- Wiki version 3.0.4.560.